By admin - Last updated: Friday, March 3, 2017
If the target table containing column with spatial datatype, and you like to do the following query, SELECT * FROM [LinkedServerName].[DatabaseName].dbo.MyPolygon it will return Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object The work around is SELECT * FROM OPENQUERY([LinkedServerName], ‘SELECT * [...]